package com.ruoyi.bizsys.mapper;

import java.util.List;

import com.ruoyi.bizsys.domain.ProductInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * 产品信息Mapper接口
 *
 * @author african-loan
 * @date 2021-12-30
 */
public interface ProductInfoMapper extends BaseMapper<ProductInfo>{

    @Select("select show_interest_rate,interest_rate,tags from product_info where credit_rating=#{creditRating} order by interest_rate asc limit 1")
    ProductInfo getTags(String creditRating);
}
